SELECT
	cat.name as Category, 
	evt.name as EventName, evt.trace_event_id,
	col.name as ColumnName, col.trace_column_id,
	col.type_name + 
		CASE WHEN col.type_name NOT IN ('nvarchar') THEN ''
			ELSE '('+CAST(col.max_size AS VARCHAR)+')'
		END AS ColumnType,
	col.is_filterable,
	col.is_repeatable,
	col.is_repeated_base
FROM sys.trace_events AS evt
JOIN sys.trace_event_bindings AS bind
	ON evt.trace_event_id = bind.trace_event_id
JOIN sys.trace_columns AS col
	ON bind.trace_column_id = col.trace_column_id
JOIN sys.trace_categories AS cat
	ON evt.category_id = cat.category_id;
